Skip to main content

Pivot Drill Disable

Pivot Drill Disable: This video contains how does pivot disable drill works in the dashboard in OPNBI.

  • This document describes how users can disable the Pivot drill function in the pivot widget. By default, drill, data checkbox is enabled, but in case if users do not want it, they can disable it from widget edit settings.

  • Follow the below steps to learn how we can disable the pivot drill.

  1. From Right Vertical Menu Select the Pivot Widget icon.

  2. The Edit menu box appears as you click on the Pivot widget icon. And a widget gets added in content place automatically in the dashboard.

  3. Enter the Following details in Pivot Table:

  • Type: Table
  • Dataset: sales.ds

  1. Drag and drop country, year in rows and month in Columns, and quantityOrdered in Values.

  2. In value click on Setting Icon and enter the Following Details.

  • Type: Sum
  1. Fill above details in the edit box, As Shown in the figure below:

Docusaurus Slash Introduction

  1. Click on Preview and Save and Exit.

  2. Click on the quantity Ordered of Austria and you can see the drill data of that country, as shown in the figure below:

Docusaurus Slash Introduction

  1. Click on the edit icon of the pivot widget and enter the following details in a pivot.

Docusaurus Slash Introduction

Select Disable pivot drill data, as shown in figure below:

  1. Click on preview and save and exit.

  2. Now, click on Canada quantity ordered and you can see that drill data is disabled.